Tabela SnomedDescription

Definicja tabeli SnomedDescription

Name

SnomedDescription

Code

SnomedDescription

Comment

Opis pozycji slownika SNOMED


Lista kolumn tabeli SnomedDescription

Name

Code

ID

ID

EffectiveTime

EffectiveTime

Active

Active

ModuleID

ModuleID

ConceptID

ConceptID

LanguageCode

LanguageCode

TypeID

TypeID

Term

Term

CaseSignificanceID

CaseSignificanceID


Kolumna ID tabeli SnomedDescription

Definicja kolumny ID tabeli SnomedDescription

Name

ID

Code

ID

Data Type

VARCHAR2(18)

Mandatory

Yes

Comment

ID opisu pozycji slownika SNOMED


Kolumna EffectiveTime tabeli SnomedDescription

Definicja kolumny EffectiveTime tabeli SnomedDescription

Name

EffectiveTime

Code

EffectiveTime

Data Type

DATE

Mandatory

Yes

Comment

Znacznik czasu aktualnosci rekordu


Kolumna Active tabeli SnomedDescription

Definicja kolumny Active tabeli SnomedDescription

Name

Active

Code

Active

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Flaga aktywnosci


Kolumna ModuleID tabeli SnomedDescription

Definicja kolumny ModuleID tabeli SnomedDescription

Name

ModuleID

Code

ModuleID

Data Type

VARCHAR2(18)

Mandatory

Yes

Comment

Identyfikator modulu SNOMED


Kolumna ConceptID tabeli SnomedDescription

Definicja kolumny ConceptID tabeli SnomedDescription

Name

ConceptID

Code

ConceptID

Data Type

VARCHAR2(18)

Mandatory

Yes

Comment

ID pozycji slownika


Kolumna LanguageCode tabeli SnomedDescription

Definicja kolumny LanguageCode tabeli SnomedDescription

Name

LanguageCode

Code

LanguageCode

Data Type

VARCHAR2(2)

Mandatory

Yes

Comment

Kod jezyka


Kolumna TypeID tabeli SnomedDescription

Definicja kolumny TypeID tabeli SnomedDescription

Name

TypeID

Code

TypeID

Data Type

VARCHAR2(18)

Mandatory

Yes

Comment

Typ opisu SNOMED


Kolumna Term tabeli SnomedDescription

Definicja kolumny Term tabeli SnomedDescription

Name

Term

Code

Term

Data Type

VARCHAR2(2048)

Mandatory

Yes

Comment

Opis


Kolumna CaseSignificanceID tabeli SnomedDescription

Definicja kolumny CaseSignificanceID tabeli SnomedDescription

Name

CaseSignificanceID

Code

CaseSignificanceID

Data Type

VARCHAR2(18)

Mandatory

Yes

Comment

Wielkosc liter


Lista kluczy tabeli SnomedDescription

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli SnomedDescription

Definicja klucza Identifier_1 tabeli SnomedDescription

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment